home *** CD-ROM | disk | FTP | other *** search
/ Software of the Month Club 1996 May / Software of the Month Club 1996 May.iso / mac / ISO9660 / OS2 / MESA / EXAMPLES / FEATURES.M2 < prev    next >
Encoding:
Text File  |  1995-09-27  |  36.4 KB  |  45 lines  |  [TEXT/hscd]
  1. Mesa2DPP#Gtù _¢ÇVⁿ   √   ê`                
  2.                                                                                                                                         ú≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡? 1       └└└╠╠╠└└└
  3. SmartFillHhG»,, ¥       └└└╠╠╠└└└ SmartFill++H░ 
  4.    └└└╠╠╠└└└Drag and DropHhG» ä
  5.    └└└╠╠╠└└└Colors/FontsH░ É
  6. m LdHHHH Helv Helv Helv Helv Helv Helv Helv Helv▒    É╪ h@⌡    É╪ h@9    É╪ h@}    É╪ h@┴    É╪ h@   É╪ h@I   É╪ h@ì   É╪ h@╤   É╪ h@   É╪ h    @Y   É╪ h
  7. @¥   É╪ h @ß   É╪ h @%   É╪ h@i   É╪ h@¡   É╪ h@±   É╪ h@5   É╪ h@y   É╪ h@╜   É╪ h@└└└É╪ hE└└└É╪ hë └└└É╪ h═ └└└É╪ h  É╪ hU  É╪ hÖ    É╪ h▌└└└É╪ h!    É╪ he    É╪ h⌐    É╪ hφ  É╪ h1   É╪ h@u└└└╪h╣└└└É╪h²└└└ÉhA└└└╪ hà└└└É h╔└└└╪ A└└└É╪ @Q└└└É DòÇÇÇÉ╪ h┘   ÇÇÇÉ╪ h└└└╪ha└└└É╪hÑ└└└ÉhΘ└└└╪A-└└└É╪@q└└└ÉD╡└└└╪h∙└└└h=└└└╪@ü└└└D┼└└└h    └└└@M└└└hæ└└└h╒└└└h└└└U]└└└ÉTí   ÇÇÇÉ╪ hσ ÇÇÇÉ╪ h) ÇÇÇÉ╪ hm   h@▒   U@⌡   ╪h@9   É╪h@}   Éh@┴   ╪ h@   É h@I   ╪ A@ì   É╪ @@╤   É D@   h@Y   h@¥   ÉT@ß └└└É╪ h%    └└└É╪ hi     Éh@¡     h@±  └└└É╪ h5! └└└É╪ hy!    h@╜!    E@"└└└ hE"└└└ Eë"   h@═"   Éh@#└└└ÉTU#   h@Ö#   Éh@▌#└└└ÉT!$└└└h    e$└└└ h    ⌐$└└└ E    φ$    U@1%     e@u%└└└É d╣%    e@²%   É d@A&   E@à&   ÉD@╔&   e@'   Éd@Q'    e@ò'    e@┘'└└└Éd(└└└ha(└└└UÑ(└└└hΘ(└└└U-)└└└hq)└└└U╡)└└└└└└É╪ h∙)└└└   É╪ h@=* └└└É╪ hü*   É╪ h@┼*    É╪ h@    +    É╪ h@M+    É╪ h@æ+    É╪ h@╒+   É╪ h@,    É╪ h@], └└└É╪ hí, └└└É╪ hσ, └└└É╪ h)- └└└É╪ hm-   É╪ h@▒-└└└h⌡-└└└ h9.└└└ E}. └└└É╪ h┴. └└└É╪ h/   É╪ h@I/└└└É╪ hì/└└└h╤/└└└U0└└└└└└É╪ hY0 └└└É╪ h¥0 ╠╠╠É╪ hß0 ╠╠╠É╪ h%1╠╠╠É╪ hi1 ╠╠╠É╪ h¡1╠╠╠h±1╠╠╠ h52╠╠╠ Ey2╠╠╠É╪ h╜2╠╠╠Éd3╠╠╠hE3╠╠╠Uë3└└└╠╠╠É╪ h₧3 Helv│3Helv╚3Helv▌3Helv≥3Helv4Helv4Helv14HelvF4Helv[4Helvp4Helvà4HelvÜ4Helv»4!Helv─4%Helv┘4)Helvε4.Helv53Helv59Helv-5@HelvB5 HelvW58Helvl51Helvü5+Helv¢5
  8. Helvetica║5Helvetica Bold╫5Tms Rmn Bold÷5Helvetica Bold6
  9. Helv Bold*6
  10. HelveticaI6Helvetica Boldh6 Helvetica Bold    Ω6╚0=■QO    Graph  1        Helv        l7╚α   ▄   ä:    Graph  2        Helv        ε7╚(>    Graph  4        Helv        p8╚ ±   τ   U-    Graph  3        Helv    
  11. ╞8.,$.,╛.,£,. DM÷8>ï        Mesa 2 Features9╘î        69î        V9Dî        v9╘ î        û9î        ╢9ì        ╓9        ÷9x        :TR        6:        V:        v:        û:        ╢:        ╓:ì        ÷:        ];        FFMesa 2 includes a wide variety of features that make building complex };        ¥;        ╜;        ▌;        ²;        <ì        =<        ï<>        --spreadsheets easy to do and simple to update.½<        ╦<        δ<         =        +=        K=ì        k=        ï=        ½=        ╦=        δ=         >        +>        K>ì        k>        ò>Ä                SmartFill╡>tì        ╒>T1ì        ⌡>D3ì        ?9ì        5?ì        U?ì        u?        ò?TR        ╡?        ╒?        ⌡?        @        5@        U@ì        u@        σ@>        OOSmartFill allows you to fill related information with as few steps as possible.A        %A        EA        eA        àA        ÑAì        ┼A        σA²        B        %B        EB        eB        àB        ÑBì        ┼B        σB            C            )C    VIÅ        @Å@IC            iC            ëC            ⌐C    ì        ╔C            ΘC
  12.             D
  13.         )D
  14. É        ID
  15.         iD
  16.         ëD
  17.         ⌐D
  18. ì        ╔D
  19.         ΘD             E         )E É        IE         iE         ëE         ⌐E ì        ╔E         ΘE             F         )F É        IF         iF         ëF         ⌐F ì        ╔F         ΘF            G        )GÉ        IG        iG        ëG        ⌐Gì        ╔G        ΘG            H        )HÉ        IH        iH        ëH        ⌐Hì        ╔H        ΘH            I        )Iæ        II        iI        ëI        ⌐Iì        ╔I        ΘI            J        )J        IJ        iJ        ëJ        ⌐Jì        ╔J        7KU_        MMSelect this range and then select the Range ->Fill->Fill Smart with Base CellWK        wK        ùK        ╖K        ╫K        ≈Kì        L        éLU_        JJmenu item.  Notice that the other cells now contain the next number in theóL        ┬L        ΓL        M        "M        BMì        bM        ╨MU_        MMseries.  SmartFill works with many other types of data including words, days,≡M        N        0N        PN        pN        ÉNì        ░N        OU_        KKmonths and dates.  Change the base cell to January and watch how the values<O        \O        |O        £O        ╝O        ▄Oì        ⁿO        7PU_        in the other cells change.WP        wP        ùP        ╖P        ╫P        ≈Pì        Q        7Q        WQ        wQ        ùQ        ╖Q        ╫Q        ≈Qì        R        7R        WR        wR        ùR        ╖R        ╫R        ≈RD"ì        S        7S        WS        wS        ùS        ╖S        ╫S        ≈S        T        7T         WT!        wT"        ùT#        ╖T$        ╫T%        ≈T&        U'        7U(        WU)        wU*        ½UE4Ä        Formula Inheritance╦Utì        δUD(ì         VTaì        +V1ì        KVTsì        kVTIì        ïVTR        ½V w        ╦VÆ        4WEl        HHSmartFill can work on Formulas as well.  We call this technology FormulaTWÆ        ╚Wt        SSInheritance.  It allows different cells to use the same formula to act on differentΦWÆ        X>        data..XÆ        NXx        nXTIE        ûX"N        Store 1ΓXEtN$$µ  J    Store 2.YUeN$$τ  J    Store 3NYÆ        nYx        òYUeO        Week 1╣YTV        Y@▌YtV        i@ZFsV        └b@!ZÆ        AZw        îZE6O$$δ   J    Week 2░Z8V        Ç[@╘ZV        α`@°Z
  20. V        αe@[Æ        c["O$$±   J    Week 3ç[GW        └\@½[GW        └r@╧[GW        @o@∩[Æ        :\    U(O$$÷   J    Week 4^\    GW        @_@é\    GW        αo@ª\    GW        @Z@╞\    Æ        ε\
  21. Eeh        Summary]
  22. Nô        .]
  23. Drô        N]
  24. =ô        n]
  25. Æ        Ä] Æ        «] Æ        ╬]Æ        7^U_        HHSelect the highlighted range and type =SUM(C7:C10) into the Formula Bar.W^Æ        ╩^U_        RRNow type Shift-Enter to SmartFill the formula.  Notice that all of the other cellsΩ^Æ        U_U_        JJin the range sum the data above it.  This feature works with all functionsu_Æ        ▌_U_        GGMesa 2 supports, allowing you to build complex workbooks with a minimum²_Æ        (`U_        
  27. of effort.H`Æ        h`Æ        ¥`E4Ä        Drag and Drop Ranges╜`tì        ▌`D(ì        ²`Taì        a1ì        =aTsì        ]aD"ì        }aTR        ¥aTR        ╜a        ▌a        ²a        b        =b        ]bì        }b        Γb>        DDMesa 2 allows you to move ranges from one part of a Workbook Page toc        "c        Bc        bc        éc        ócì        ┬c        /d>        LLanother.  Select the range below and with the mouse cursor over the selectedOd        od        Åd        »d        ╧d        ∩dì        e        üe>        QQrange select the right mouse button and drag it two columns to the right.  Noticeíe        ┴e        ße        f        !f        Afì        af        └f>        >>that Mesa 2 displays the range as you move it around the page.αf        g         g        @g        `g        Çgì        ág        └g        αg        h         h        @h        `h        Çhì        áh        └h        αh        i"Å        Store 1(i        Hi        pi>        To hereÉiì        ░i        ╨i        ≡i        jTö        Y@4j        Tj        tj        öjì        ┤j        ╘j            ⌠j            k    8ö        Ç[@8k            Xk            xk            ÿk    ì        ╕k            ╪k
  28.         °k
  29.         l
  30. Gö        └\@<l
  31.         \l
  32.         |l
  33.         £l
  34. ì        ╝l
  35.         ▄l         ⁿl          m Gö        @_@@m         `m         Çm         ám ì        └m         Ωm >                From here
  36. n         ^n Nò00Bⁿ     '     |@~n         ₧n         ╛n         ▐n ì        ■n         o        >o        ^o        ~o        ₧o        ╛o        ▐oì        ■o        p        >p        ^p        ~p        ₧p        ╛p        ▐pD"ì        ■p        q        >q        ^q        ~q        ₧q        ╛q        ▐qì        ■q        r        >r        ^r        ~r        ₧r        ╛r        ▐rì        ■r        s        >s        ^s        ~s        ₧s        ╛s        ▐sì        ■s        t        >t        ^t        ~t        ₧t        ╛t        ▐tì        ■t        u        >u        ^u        ~u        ₧u        ╛u        ▐uì        ■u        v        >v        ^v        ~v        ₧v        ╛v        ▐v        ■v        w        >w        ^w        ~w        ₧w         ╛w!        ▐w"        ■w#        x$        ]xE4Ä        Drag and Drop Colors and Fonts}xtì        ¥xD(ì        ╜xTaì        ▌x1ì        ²xTsì        yTIû        =y        ]yTR        }y        ¥y        ╜y        ▌y        ²y        zû        =z        ñz>        FFMesa 2 uses the OS/2 Drag and Drop conventions.  You can drag and drop─z        Σz        {        ${        D{        d{û        ä{        ⌠{>        OOcolors and fonts from the OS/2 color and font palettes.  Select the highlighted|        4|        T|        t|        ö|        ┤|û        ╘|        =}>        HHrange below and then select the Range->Text Color->Color Palette... menu]}        }}        ¥}        ╜}        ▌}        ²}û        ~        ì~>        OOitem.  Select a color from the color palette and while pressing the right mouse¡~        ═~        φ~                -        Mû        m        ┘>        KKbutton drag it onto the selected range.  This action changes the background∙        Ç        9Ç        YÇ        yÇ        ÖÇû        ╣Ç        *ü>        PPcolor to the color you selected.  To change the text color, select another colorJü        jü        èü        ¬ü        ╩ü        Ωüû        
  37. é        }é>        RRfrom the color palette, and while pressing the Ctrl key, right drag the color onto¥é        ╜é        ▌é        ²é        â        =âû        ]â        çâ    >                the rangeºâ            ╟â            τâ            ä            'ä            Gä    û        gä            çä
  38.         ºä
  39.         ╟ä
  40.         τä
  41.         à
  42.         'à
  43.         Gà
  44. û        gà
  45.         çà         ºà         ╬à "Å        Store1εà         å         .å         Nå û        nå         Äå         «å         ╥å Tö        Y@≥å         ç         2ç         Rç û        rç         Æç        ▓ç        ╓ç8ö        Ç[@÷ç        ê        6ê        Vêû        vê        ûê        ╢ê        ┌êGö        └\@·ê        ë        :ë        Zëû        zë        Üë        ║ë        ▐ëGö        @_@■ë        è        >è        ^èû        ~è        ₧è        ╛è        ïNò00Bⁿ     '     |@2ï        Rï        rï        Æïû        ▓ï        ╥ï        ≥ï        î        2î        Rî        rî        Æîû        ▓î        !ì>        NNYou can change fonts from the OS/2 font panel.  Select the range listed above Aì        aì        üì        íì        ┴ì        ßìû        Ä        uÄ>        SSand then select the Font Palette... menu item.  Select a font from the font paletteòÄ        ╡Ä        ╒Ä        ⌡Ä        Å        5Åû        UÅ        └Å>        JJand while pressing the right mouse button drag it onto the selected range.αÅ        É         É        @É        `É        ÇÉû        áÉ        └É        αÉ        æ         æ        @æ        `æ        Çæû        áæ        ¿æ